SizeConversion

Entity Definition

Logical Name : SizeConversion
Physical Name : CO_CVN_SZ

An associative entity recording equivalence relationships between two Szes. Eg: European Shoe Size == US Shoe Size.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
FromSizeFamilyID (FK)(PK) A unique retailer assigned idendtifier for the grouping of similar colors used to classify the sizes of merchandise for analysis. ID_SZ_FMY_FRM Identity integer Size(CO_SZ)
ToSizeFamilyID (FK)(PK) A unique retailer assigned idendtifier for the grouping of similar colors used to classify the sizes of merchandise for analysis. ID_SZ_FMY_TO Identity integer Size(CO_SZ)
FromSizeCode (FK)(PK) A code to designate the size of the ITEM. It is proposed to use the 5 apparel and miscellaneous coding structure as specified by the NRF to facilitate data interchange between vendors and retailers. This code permits the use of both standard and proprietary coding format. CD_SZ_FRM Code6 char(6) Size(CO_SZ)
ToSizeCode (FK)(PK) A code to designate the size of the ITEM. It is proposed to use the 5 apparel and miscellaneous coding structure as specified by the NRF to facilitate data interchange between vendors and retailers. This code permits the use of both standard and proprietary coding format. CD_SZ_TO Code6 char(6) Size(CO_SZ)

Relationships

Parent Entity Verb Phrase Child Entity
Size converts from SizeConversion
Size converts to SizeConversion

Logical Views containing SizeConversion

Logical View
Logical 01010 - Item Description - Subtype View
Logical 01015 - Item Description - Apparel View